package com.hzhjhh.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.hzhjhh.dto.MerchandiseDTO;
import com.hzhjhh.entity.Merchandise;

/**
 * @author 12083
 * @description 针对表【sm_merchandise(商品信息表)】的数据库操作Mapper
 * @createDate 2025-04-12 22:34:07
 * @Entity com.hzhjhh.entity.Merchandise
 */
public interface MerchandiseMapper {

	static final String select1 = "select * from sm_merchandise where SortNumber=?";
	static final String select2 = "select * from sm_merchandise where MerchandiseNumber=?";
	static final String select3 = "select * from sm_merchandise where MerchandiseName=?";
	static final String select4 = "select * from sm_merchandise where TreatyCode=?";
	
	Merchandise selectOneByName(String merchandiseName);
	
	Merchandise selectOneByDTO(@Param("merchandiseDTO") MerchandiseDTO merchandiseDTO);
	
	List<Merchandise> selectListByDTO(@Param("merchandiseDTO") MerchandiseDTO merchandiseDTO);
	
	int batchInsert(@Param("merchandiseList") List<Merchandise> merchandiseList);
}
